| |
164 Search Results Found |
| 1 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 01:25 «»
By: LIPEKA
RMAN-00554 RMAN-04006
…am new to this and practicing Dataguard. I am unable to connect to standby(SALESPRDSBY ) to duplicate standby database. Using one computer(on this example).
Primary &…
|
| 2 |
Forum: Performance Tuning «»
Posted on: Thu, 27 October 2022 03:32 «»
By: esirenko
Understanding UNDO 11g
…Guys,
Couple of month ago i faced UNDO issue at my database. Now it is always full and system ask to add some space. I have added another 32GB autoextensible file now it is 32+32+32, but in a couple days, situation repeated.
Previously i just ajusted…
|
| 3 |
Forum: Data Guard «»
Posted on: Tue, 21 April 2020 00:50 «»
By: rajesh_b
Re: Unable to connect stand by
…
Primary
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RIE-OTEST-VM.arg.internal)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
-------------------------------
…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 20 February 2019 03:00 «»
By: Michel Cadot
Re: Parallel DDL statements in a same table with different partitions
…
You can do the same king of test.
First create a DDL trigger to have the time to see what happens:
SQL> create or replace trigger ddl_trigger
2 after ddl on michel.schema
3 begin
4 if ora_dict_obj_name = 'TEST' then
5 …
|
| 5 |
Forum: Networking and Gateways «»
Posted on: Mon, 28 May 2018 04:46 «»
By: JaviCZ
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
…have two Intranet servers and one in the cloud that connects me through VPN. My intention is to be enabled for REDUCTION and for that I need to do a Shutdown and a Starup. but in doing so he returns me:
ORA-12514: TNS:listener does not currently know …
|
| 6 |
Forum: Linux «»
Posted on: Tue, 01 August 2017 10:34 «»
By: chrisindya
Re: Not able to connect SQLPLUS in Susi Linux OS
…Michel,
The results for 3 commands below for the new user (oracle owner user) 'oraclecloud'
oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> env | sort
COLORTERM=1
CPU=x86_64
CSHEDIT=emacs
DISPLAY=:2.0
ENV=/etc…
|
| 7 |
Forum: Server Administration «»
Posted on: Tue, 25 April 2017 05:42 «»
By: trantuananh24hg
SQL Statement can not be traced
…afternoon,
I have a strange case today, till now, I have not had any idea to track the SQL Statement, so, post here with your help. Brief as following:
1- Instance activity…
|
| 8 |
Forum: Unix «»
Posted on: Tue, 14 February 2017 07:40 «»
By: tsar
Re: Getting errors when starting listener
…
oraamp> id
uid=3203(oraamp) gid=200(dba) groups=101(oper)
> env | sort
COLUMNS=197
EDITOR=vi
ENV=/oracle/AMP/.kshrc
ERASE=^H
FCEDIT=vi
HISTFILE=/oracle/AMP/.sh_history_dev_pts_2
HOME=/oracle/AMP
LD_LIBRARY_PATH=/oracle/AMP/lib
…
|
| 9 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:12 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DISPLAY job command
After the LIST command the first thing that comes in mind is "can I have more information about this specific job?" and the answer is "Yes, using the DISPLAY command on this job".
Its syntax is:
McDP [<…
|
| 10 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 16 August 2016 11:06 «»
By: dane1954
ENV Vars for ProC on Linux
…am having a problem getting proc to run on linux (suse I believe). I suspect the problem
is one of undefined or incorrectly defined environment variables. In my environment I have
defined (note: ... indicates not relevant but correct parent directory …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 25 March 2016 04:01 «»
By: Michel Cadot
Re: Table LOCK
…
Row Share, are you sure? It seems to me that since a patchset of 10.2 it is Row Exclusive due to some internal dead locks in RAC or maybe this has change in 12c.
In 11.2:
SQL> select * from t for update;
EID FNAME LNAME SSN…
|
| 12 |
Forum: Backup & Recovery «»
Posted on: Tue, 16 December 2014 23:40 «»
By: shaikali
rman
…Hi, I am getting the below error, please help to fix the issue.
C:\>set ORACLE_SID=rman
C:\>rman target /
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 08 November 2014 13:50 «»
By: dariyoosh
Re: Question about tracing Web Applications SQL statements by using oracle AUDIT command
…John and BlackSwan
First of all, I would like to thank you very much both of you for your kind help and your time. I really appreciate that.
Interesting I didn't know that this option is available, I thought that the only way was to specify each …
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 29 May 2014 12:35 «»
By: azeem87
Re: Delete getting stuck
…Yes, this was confusing for me also...
I tried to run this morning.. for the same 250K deletes.. i let it run for 1 hr.. didn't finish so cancelled it..
saw if any background stuff could cause.. make sure no backup, no stats, no other jobs were running…
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 28 May 2014 13:39 «»
By: azeem87
Re: Delete getting stuck
…for your time.
this has happened 3 times this morning and all these times i cancelled and rerun deletes after few mins it finished in secs.
yes it's index,stats are updated. please see the plan below
LAST_ANALYZED
-------------
28-MAY-14
1 row…
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 28 May 2014 12:54 «»
By: azeem87
Re: Delete getting stuck
…hi,
i happened to run this delete again and it was stuck today, cancelled it reconnected with a different session, started trace and then delete statements.
didn't finished in 10 mins.. so cancelled the deleted.. please find the output from trace. The …
|
| 17 |
Forum: Linux «»
Posted on: Sat, 17 May 2014 03:20 «»
By: treltenrenu
11g Installation problem in rhel 5.4 64 bit.
…HI,
Irecently installed 11g r2 in an liunx machine. The installation was sucessful and i got GUI EM. That's working fine. The problem is when i tried to login in cmd line like "sqlplus / sys as sysdba" that cannot be exexuted. It show …
|
| 18 |
Forum: Server Administration «»
Posted on: Mon, 17 February 2014 20:24 «»
By: kittipong.at
Database look like change to SUSPEND mode (Login only sys as sysdba allow)
…DB look like change to SUSPEND mode (Login only sys as sysdba allow)
I found this problem on production db. App can't use.
I test sqlplus on local DB. Normal user include system is authen (not show invalid user/psss)
and pending prompt return. …
|
| 19 |
Forum: RAC & Failsafe «»
Posted on: Tue, 11 February 2014 23:30 «»
By: RAJEMBAA7
Re: Unable to to start One node
…
Hi, I am not able to see any difference except oracle home and sid set in node 2
Node 1
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\oradbadmin\AppData\Roaming
CLIENTNAME=GIT-RAJESHB-PC
CommonProgramFiles(x86)=C:\Program Files (x86)\Common …
|
| 20 |
Forum: RAC & Failsafe «»
Posted on: Tue, 11 February 2014 09:01 «»
By: RAJEMBAA7
Unable to to start One node
…Members,
I am new to Oracle RAC, I have installed a 2 node oracle rac with 11gr2 on windows 2008 r2. Every thing went successfully
I have created the database and did testing. Today I have restarted the nodes after that I am unable to start both the …
|
| 21 |
Forum: Networking and Gateways «»
Posted on: Thu, 08 August 2013 20:12 «»
By: BlackSwan
Re: listener issues
…>SQL> startup
>ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
what additional clues exist within alert_SID.log file?
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/…
|
| 22 |
Forum: Backup & Recovery «»
Posted on: Thu, 09 May 2013 07:50 «»
By: Andrey_R
Restore & Recover controlfile after its deletion from a Backup Set
…all,
I am doing some tests to on backup & recovery scenarios on a testing VM.
I've set the database to archivelog, bounced the database:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> shutdown immediate;
…
|
| 23 |
Forum: Enterprise Manager «»
Posted on: Wed, 24 April 2013 16:38 «»
By: its@tdcp.gop.pk
Re: EM Daemon is not running.
…Re: Install Oracle 11gR2 Error?
Posted: Apr 24, 2013 2:20 PM in response to: Junaid in response to: Junaid
em_daemon_is_not_running , agent_is_not_running , em_internal_error , error_database_control , time_zone_problem [Edit]
Click to edit …
|
| 24 |
Forum: Data Guard «»
Posted on: Fri, 19 April 2013 09:10 «»
By: ramanujam.y@gmail.com
Difficulties in configuring Data Guard environment
…HI,
I am new to DBA. i am trying to setup a datagaurd environment. but i am facing some difficulties in configuring. can some one please help me to achieve this datagaurd configuration.
My primary database name is ourdb and stand by is oursby
steps…
|
| 25 |
Forum: Enterprise Manager «»
Posted on: Mon, 01 April 2013 09:30 «»
By: taoqir.hassan
Error to Login EM
…Hi,
After installing oralce 11g,set env variables and tried to login EM,and get this error
C:\>Set oracle_unqname=orcl
c:\>set oracle_sid=orcl
Error:Error:Internal Error has occured.Check the log file for details.
i looked to oracle service …
|
| 26 |
Forum: Enterprise Manager «»
Posted on: Sat, 09 March 2013 01:26 «»
By: ansar5
Enterprise manager is not working
…Hi!
I am having problem with EM for Oracle DB 11.2.0.1 on windows 7. I performed following steps in order.
1 - Installed oracle software only from Oracle 11gR2 setup
2 - assigned IP address as 192.168.14.252, gateway as 192.168.14.1, dns server …
|
| 27 |
Forum: Server Administration «»
Posted on: Fri, 11 January 2013 07:48 «»
By: dbcop
Data Block Corruption even after repaired
…Gurus,
An error diplayed in the application log as
"Database error text........: "ORA-01578: ORACLE data block corrupted (file #
239, block # 333600)#ORA-01110: data file 239:
'/oracle/BT5/sapdata3/sr3_202/sr3.data202'"
Internal …
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 08 January 2013 05:59 «»
By: horicel
Re: why does SELECT DISTINCT return different rows when used with ORDER BY?
…Michel,
I do not have a repro sequence, starting with CREATE TABLE etc. that leads to the erroneous behaviour.
What I do have is the possibility of running the queries over and over ( on the tables that I have already populated ) in order to see the …
|
| 29 |
Forum: Enterprise Manager «»
Posted on: Thu, 29 November 2012 11:53 «»
By: sam524
Re: severe : error starting database control
…my log file is as follows:
29/11/2012 18:26:28 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-config' set to true
29/11/2012 18:26:28 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'UPDATE_EMAIL' set to true
29/11/2012 18:26:28 …
|
| 30 |
Forum: Server Administration «»
Posted on: Wed, 31 October 2012 13:07 «»
By: krish96
Re: how to migrate database from windows 2003 to windows 2008 server
…have removed semicolons and here is the samething
C:\>set ORACLE_SID=testdb
C:\>set ORACLE_HOME=C:\oracle\product\11.2.0\dbhome_1
C:\>set TNS_ADMIN=C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
C:\>set ORA_NLS33=$ORACLE_HOME\ocommon\…
|
| 31 |
Forum: Server Administration «»
Posted on: Wed, 31 October 2012 12:38 «»
By: krish96
Re: how to migrate database from windows 2003 to windows 2008 server
…hi,
i am unable to connect to rman
C:\>set ORACLE_SID=testdb;
C:\>set ORACLE_HOME=C:\oracle\product\11.2.0\dbhome_1;
C:\>set TNS_ADMIN=C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN;
C:\>set ORA_NLS33=$ORACLE_HOME\ocommon\nls\admin\…
|
| 32 |
Forum: Server Utilities «»
Posted on: Sat, 25 August 2012 06:49 «»
By: vchenna
SQLLDR connection error
…
The SQLLDR fails with connection error:
SQLLDR userid=userid/passwd@vpl01 control=OtherType.ctl log=OtherType.log bad=OtherType.bad
SQL*Loader: Release 11.2.0.1.0 - Production on Sat Aug 25 13:32:42 2012
Copyright (c) 1982, 2009, Oracle and/…
|
| 33 |
Forum: Performance Tuning «»
Posted on: Thu, 03 May 2012 22:05 «»
By: Kevin Meade
Re: How we can find %age completion of query when is in running status
…question is difficult to answer and at the same time easy.
1) it is correct, that given Oracle's default consistency model, it is not possible to see the results of an insert/update/delete before it is committed. Therefore you cannot create a process …
|
| 34 |
Forum: Backup & Recovery «»
Posted on: Wed, 22 February 2012 12:44 «»
By: SPenn
Recover Database Error
…searched this website for my current error message but to no avail. Please assist if you can.
D:\DBA>set o
ORACLE_HOME=D:\oracle\product\10.2.0\db
ORACLE_SID=SIRSTEST
oraenv=oraenv
OS=Windows_NT
D:\DBA>sqlplus /nolog
SQL*Plus: Release …
|
| 35 |
Forum: Linux «»
Posted on: Sun, 25 September 2011 07:39 «»
By: JiXO
Re: Enterprise Manager error
…is the content from emdctl.trc now
2011-09-25 14:45:31,628 Thread-3036149440 WARN http: nmehl_connect_internal: connect failed to (localhost.localdomain:1158): Connection refused (error = 111)
2011-09-25 14:45:31,628 Thread-3036149440 ERROR …
|
| 36 |
Forum: Linux «»
Posted on: Sat, 24 September 2011 14:56 «»
By: JiXO
Re: Enterprise Manager error
…is the content of alert_orcl.log
Thu Sep 22 17:17:33 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using …
|
| 37 |
Forum: Data Guard «»
Posted on: Wed, 10 August 2011 11:28 «»
By: kytemanaic
switchover fails becoz of ORA-12514: TNS:listener does not currently
…
here's my rdbms version and os:
SYS@cta>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - …
|
| 38 |
Forum: Enterprise Manager «»
Posted on: Fri, 08 July 2011 00:26 «»
By: fribergb
EM warning EM won't run after default 64-bit 11gR2 install
…
All,
I've inherited a 10.2 instance here in Kuwait and I'm attempting to migrate to a brand new server; I downloaded and attempted to install 11gR2 (11.2.0.1.0) on my brand new HP clean and patched server running Windows 2008 R2 Enterprise.
I'…
|
| 39 |
Forum: Networking and Gateways «»
Posted on: Wed, 25 May 2011 06:16 «»
By: ThomasG
Re: Connecting Oracle to SQL Server via database link
…sqlserver.db entry?
The entry you do in the "create database link" should point to the an entry in the tnsnames.ora used.
From an old backup I was able to re-construction the "configuration chain" through Oracle, ODBC and the …
|
| 40 |
Forum: Backup & Recovery «»
Posted on: Mon, 09 May 2011 05:01 «»
By: x-oracle
Re: NID- utility giving ora-01103 error
…by step steps are here
here we have to change dom database name to don
how can we change database name i have mention my step by step activity here
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved…
|
Blog
Search
Help
Members
Register
Login
Home